This registry variable causes the optimizer to favor nested loop joins to join the list of values, using the table that contributes the IN list as the inner table in the join. 这个注册表变量会导致优化器优先使用嵌套循环连接来连接值列表,使用为IN列表提供值的表作为连接的内部表。
Typically, the optimizer chooses merge scan join when the cardinality of the outer input is not obviously small and there is no efficient access method for the inner table. 通常情况下,在外部输入的基数显然不小且对于内部表没有一种有效的访问方法时,优化器会选择合并扫描联接。
The index exploited for the inner table happens to be a clustered index. 利用内部表的索引恰好是一个聚集索引。
Next, we have to create the inner table. 接下来,我们必须要创建内部表格。
For example, an inner table contained in a table is a second-level report item. 例如,表格中所包含的一个内部表格,就是一个二级层次的报表项目。
Therefore, the order of consecutive probes into the inner table could impact the I/ O performance of the inner table significantly. 因此,连续探测内部表的顺序可能会显著地影响内部表的I/O性能。
The work items may contain sub-work items; therefore the inner table should include an embedded inner table and link table. 工作项可能包含有子工作项;因此内部表格应该包含一个嵌入的内部表格和联系表格。
Under Sub-Category, click Table, which refers to the outer table of users, not the inner table of work items. 在Sub-Category之下,点击Table,它会引用用户外层表格,而不是工作项的内层表格。
From the performance perspective, this is considered a very efficient join operation, because the cost for scanning the inner table is optimal via unique access through a unique index. 从性能的角度来看,这被认为是一个非常有效的联接操作,因为通过贯穿唯一索引的唯一访问扫描内部表的成本是最优的。
That is, the inner table of the join operation will be scanned eight times, once for each of the eight qualifying records from the outer input. 也就是说,联接操作的内部表将被扫描8次,来自外部输入的8个合格的记录每个都将被扫描一次。
In general, a nested loop join with sort composite is favored by the optimizer if the inner index is well-clustered and the inner table is expected to be probed many times. 一般来说,如果内部索引是良好的集群且预测内部表被多次探测,则使用复合排序的嵌套循环联将受到优化器的青睐。
The higher the cardinality, the more probes into the inner table, one per qualifying ( outer) record. 基数越高,进入内部表、每一条合格的(外部)记录的探测就越多。
With this design, the inner table retrieves only one work item at a time, so that as the sub-work items count increases, it takes an increasingly longer time to build the report. 有了这个设计,内部表格一次只获取一个工作项,这样随着子工作项数量的增加,构建报表就需要花费更长的时间。
One record of the inner table will match each qualifying record from the outer table ( Inner Input Cardinality value is1). 一条内部表的记录将与来自外部表的每条合格的记录相匹配(内部输入基数值是1)。
The number of rows retrieved from the outer table after the database server applies any table filters is small, and the inner table has an index that can be used to perform the join. 在数据库服务器使用所有表筛选器之后,从外部表检索出的行数将很少,而内部表具有一个可用于执行连接的索引。
If the inner table does not have an index, the database server will compare the cost of building an index on the table to the cost of a sequential scan, and will choose the one with the least cost. 如果内部表没有索引,那么数据库服务器就会将在表上构建索引的成本与连续扫描的成本进行比较,然后选择成本最低的那一种方法。
For this report to make sense, you must limit the inner table to show only the work items that are owned by the user in the outer table row. 为了实现这一份报表,您必须将inner表格限制为只显示outer表格行中用户所拥有的工作项。
Then we can create an inner table out of the link table, using the global variable as the inner table's WORK_ITEMID parameter value. 然后我们可以使用全局变量作为内部表格的WORKITEMID参数值,来在联系表格外面创建一个内部表格。
In this way, the inner table is an element of the outer table's cell, and the onRender events of the table, detail row and cell are firing before the inner table does. 通过这种方式,内部表格就是外部表格单元的一个元素,以及表格的onRender事件,具体行和单元会在内部表格操作之前引发。
Because the inner table is scanned with TBSCAN, which does not guarantee the expected order for MSJOIN, a SORT node is added to enforce the order. 因为通过TBSCAN扫描内部表,即不能对MSJOIN保证预期的顺序,所以添加SORT节点来执行顺序。
Now the inner table shows only the links that have the work item in the outer table as a target. 现在内部表格只是显示了外层表格中的工作项作为目标。
You can do this by passing a parameter ( in this case, the owner's user ID) from the outer table row to the inner table. 您可以通过从外层表格向内层表格发送一个参数(在本例中,是所有者的用户ID),来实现这项任务。
For every row found in the outer table, the database server searches for its corresponding row in the second ( or inner) table. 对于在外部表中找到的每一行,数据库服务器将在第二个(或内部)表中搜索其相应的行。
However, the benefit of the merge scan join is that the inner table does not have to be scanned repeatedly as it does for nested loop joins. 然而,合并扫描联接的好处是不必反复地扫描内部表因为其为嵌套循环联接工作。
Therefore, when deciding which join method to choose, the optimizer balances the sort cost and the performance benefit for the inner table scan to drive the decision. 因此,在决定选择哪种联接方法时,优化器为内部表扫描平衡排序成本和性能优势以便促进决策。
For work items found in the deeper levels, we can embed new link tables and inner tables into the existing inner table the same way. 对于更深层次中找到的工作项,我们可以按照相同的方式,将新的联系表格和内部表格嵌入到已存在的内部表格之中。
The surgeon needs to be careful when penetrating the inner table to minimize any potential for parenchymal injury. 在钻内表时,外科医生需谨慎,以降低损害脑实质的风险。
For full-thickness grafts, also strip the iliacus muscle from the inner table of the ilium ( Fig. 1-22). 如切取全层骨块也需从髂骨内侧骨板剥离髂肌(图1-22)。
Characteristic findings of occipital arachnoid granulations on CT were semiorbicular or semilunar depression of occipital inner table, or a punched-out like bone defect from the inner table into the outer table. 枕骨蛛网膜颗粒压迹在CT上表现为半圆形、半卵圆形或浅弧形,少数可呈穿凿样骨质缺损,深达板障或外板。
At the actualization of the inner code table, the hash table and the sort search are integrated to improve the speed of searching character. 在输入法内部码表实现中,采用了哈希表与顺序查找相结合的方法,提高了字符的查找速度。